﻿IF EXISTS (SELECT * from sys.procedures p left join sys.schemas s on p.schema_id = s.schema_id where p.name='connector_select' and s.name='Meta')
DROP PROCEDURE [Meta].connector_select
GO
CREATE PROCEDURE [Meta].connector_select 
@PK uniqueidentifier
AS
BEGIN
SELECT 	
	[Connectors].[id_connector] AS [PK],
	[Connectors].[type] AS [Type],
	[Connectors].[login] AS [Login],
	[Connectors].[password] AS [Password],
	[Connectors].[params] AS [Params]
FROM 
	[Connectors] 
WHERE
	[Connectors].[id_connector] = @PK 
END